9.5 KB · ⇊ 3 parts · ⤓ Micron 9.5 KB · ⤓ HTML 27.3 KB

layout: Wide · Narrow · Centered

top

This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment.

• General

• Features

• See also

| Tool | Creator |

|---|---|

| Astah | Change Vision |

| Database Workbench | Upscene Productions |

| DbSchema | Wise Coders GmbH |

| Enterprise Architect | Sparx Systems |

| ER/Studio | Embarcadero (acquired by IDERA) |

| Erwin Data Modeler | Logic Works (now Quest) |

| MagicDraw | No Magic |

| SQL Server Management Studio | Microsoft |

| ModelRight | ModelRight |

| MySQL Workbench | MySQL (An Oracle Company) |

| Navicat Data Modeler | PremiumSoft |

| NORMA Object-Role Modeling | Terry Halpin |

| Open ModelSphere | Grandite |

| Oracle SQL Developer Data Modeler | Oracle |

| PowerDesigner | SAP |

| Software Ideas Modeler | Dusan Rodina |

| SQLyog | Webyog, Inc. |

| Toad Data Modeler | Quest Software |

| Tool | Creator |

| Tool | Target Business Size | License |

|---|---|---|

| Astah | Enterprises | Proprietary |

| Database Workbench | SMBs and enterprises | Proprietary |

| DbSchema | SMBs and enterprises | Proprietary |

| Enterprise Architect | SMBs and enterprises | Proprietary |

| ER/Studio | SMBs and enterprises | Proprietary |

| Erwin Data Modeler | SMBs and enterprises | Proprietary |

| MagicDraw | Enterprises, SMBs, personal | Proprietary |

| SQL Server Management Studio | Un­known | Proprietary |

| ModelRight | Enterprises, SMBs, personal | Proprietary |

| MySQL Workbench | SMBs - personal | Proprietary or GPL |

| Navicat Data Modeler | SMBs and enterprises | Proprietary |

| NORMA Object-Role Modeling | SMBs and enterprises | Open source ( CPL ) |

| Open ModelSphere | Enterprises - SMBs - personal | Open source ( GNU GPL3 ) |

| Oracle SQL Developer Data Modeler | Enterprises | Proprietary |

| PowerDesigner | SMBs and enterprises | Proprietary |

| Software Ideas Modeler | Enterprises, SMBs, personal | Proprietary |

| SQLyog | Enterprises, SMBs, personal | Proprietary |

| Toad Data Modeler | SMBs and enterprises | Proprietary |

| Tool | Target Business Size | License |

| Tool | Supported Database Platforms |

|---|---|

| Astah | MySQL , Oracle , |

| Database Workbench | MS SQL Server , MySQL , Oracle , Firebi… |

| DbSchema | MS SQL Server , MySQL , Oracle , Firebi… |

| Enterprise Architect | IBM Db2 , Firebird , InterBase , Inform… |

| ER/Studio | Access , Snowflake , Microsoft Azure IB… |

| Erwin Data Modeler | Access , IBM Db2 , Informix , MySQL , M… |

| MagicDraw | MS SQL Server , Oracle , MySQL , Postgr… |

| SQL Server Management Studio | MS SQL Server |

| ModelRight | Access , MS SQL Server , Oracle , MySQL… |

| MySQL Workbench | MySQL |

| Navicat Data Modeler | MySQL , MS SQL Server , PostgreSQL , Or… |

| NORMA Object-Role Modeling | MySQL , MS SQL Server , PostgreSQL , Or… |

| Open ModelSphere | MS SQL Server , MySQL , PostgreSQL , Or… |

| Oracle SQL Developer Data Modeler | Oracle , MS SQL Server , IBM Db2 |

| PowerDesigner | Access , Greenplum , Apache Hive , HP N… |

| Software Ideas Modeler | MS SQL Server , MySQL |

| SQLyog | MySQL , MariaDB |

| Toad Data Modeler | Access , IBM Db2 , Informix , MySQL , M… |

| Tool | Supported Database Platforms |

| Tool | Supported OSs |

|---|---|

| Astah | Windows, macOS, Linux |

| Database Workbench | Windows, Linux and FreeBSD (both throug… |

| DbSchema | Windows, Linux, macOS |

| Enterprise Architect | Windows, Linux (Wine), macOS (via Cross… |

| ER/Studio | Windows |

| Erwin Data Modeler | Windows |

| MagicDraw | Windows, Linux, macOS |

| SQL Server Management Studio | Windows |

| ModelRight | Windows |

| MySQL Workbench | Linux, Windows, macOS |

| Navicat Data Modeler | Windows, macOS, Linux |

| NORMA Object-Role Modeling | Windows |

| Open ModelSphere | Windows, macOS, Linux |

| Oracle SQL Developer Data Modeler | Cross-platform |

| PowerDesigner | Windows |

| Software Ideas Modeler | Windows |

| SQLyog | Windows and Linux (using Wine) |

| Toad Data Modeler | Windows |

| Tool | Supported OSs |

| Tool | Standalone or bundled into a larger too… |

|---|---|

| Astah | Standalone |

| Database Workbench | Standalone |

| DbSchema | Standalone |

| Enterprise Architect | Data modeling is supported as part of a… |

| ER/Studio | Standalone |

| Erwin Data Modeler | Standalone |

| MagicDraw | Standalone |

| SQL Server Management Studio | Standalone |

| ModelRight | Standalone |

| MySQL Workbench | Standalone |

| Navicat Data Modeler | Standalone |

| NORMA Object-Role Modeling | Visual Studio Extension |

| Open ModelSphere | Standalone with Data, UML, and process… |

| Oracle SQL Developer Data Modeler | Standalone |

| PowerDesigner | Standalone |

| Software Ideas Modeler | Standalone |

| SQLyog | Standalone |

| Toad Data Modeler | Standalone |

| Tool | Standalone or bundled into a larger too… |

| Tool | Launch Date |

|---|---|

| Astah | 2006 |

| Database Workbench | 2001 |

| DbSchema | 2018 |

| Enterprise Architect | 2000 |

| ER/Studio | 1998 |

| Erwin Data Modeler | 1998 |

| MagicDraw | 1995 |

| SQL Server Management Studio | 2005 |

| ModelRight | 2005 |

| MySQL Workbench | 2006 |

| Navicat Data Modeler | 2012 |

| NORMA Object-Role Modeling | 2005 |

| Open ModelSphere | 2008 |

| Oracle SQL Developer Data Modeler | 2009 |

| PowerDesigner | 1989 |

| Software Ideas Modeler | 2009 |

| SQLyog | 2001 |

| Toad Data Modeler | 2005 (before this date known as CaseStu… |

| Tool | Launch Date |

| Tool | Supported data models (conceptual, logi… |

|---|---|

| Database Workbench | Conceptual, logical, physical |

| Enterprise Architect | Conceptual, Logical & Physical + MDA Tr… |

| ER/Studio | Logical, physical, ETL |

| MagicDraw | Conceptual, Logical & Physical + MDA Tr… |

| MySQL Workbench | Physical |

| Navicat Data Modeler | Conceptual, Logical & Physical |

| NORMA Object-Role modeling | Conceptual (ORM), Logical, Physical |

| Open ModelSphere | Conceptual, Logical, physical |

| Oracle SQL Developer Data Modeler | Logical, physical |

| PowerDesigner | Conceptual, logical, physical |

| Software Ideas Modeler | Conceptual, logical, physical |

| Toad Data Modeler | Logical, physical |

| Tool | Supported notations |

|---|---|

| Database Workbench | IE (Crow’s foot) |

| Enterprise Architect | IDEF1X , UML DDL, Information Engineeri… |

| ER/Studio | IDEF1X, IE (Crow’s feet) |

| MagicDraw | IDEF1X, UML DDL, Information Engineerin… |

| MySQL Workbench | IDEF1X, IE (Crow’s feet), UML, and more |

| Navicat Data Modeler | IE (Crow’s foot) |

| NORMA Object-Role modeling | ORM, Relational(Crow’s foot option), Ba… |

| Open ModelSphere | IDEF1X, IE (Crow’s foot), and more |

| Oracle SQL Developer Data Modeler | Barker, IE (Crow’s foot), and Bachman |

| PowerDesigner | IDEF1X, IE (Crow’s foot), and more |

| Software Ideas Modeler | IDEF1X, IE (Crow’s foot), UML and more |

| Toad Data Modeler | IDEF1X, IE (Crow’s foot), and more |

| Tool | Forward engineering | Reverse engineering |

|---|---|---|

| Database Workbench | Yes | Yes |

| Enterprise Architect | Yes | Yes |

| ER/Studio | Yes | Yes |

| MagicDraw | Yes | Yes |

| MySQL Workbench | Yes | Yes |

| Navicat Data Modeler | Yes | Yes |

| NORMA Object-Role modeling | Yes | Yes |

| Open ModelSphere | Yes | Yes |

| Oracle SQL Developer Data Modeler | Yes | Yes |

| PowerDesigner | Yes | Yes |

| Software Ideas Modeler | Yes | Yes |

| Toad Data Modeler | Yes | Yes |

| Tool | Model/database comparison and synchroni… |

|---|---|

| Database Workbench | Update database and/or update model |

| Enterprise Architect | Update database and/or update model |

| ER/Studio | Update database and/or update model |

| MagicDraw | Update database and/or update model |

| MySQL Workbench | Update database and/or update model |

| Navicat Data Modeler | Update database and/or update model |

| NORMA Object-Role modeling | Update database and/or update model |

| Open ModelSphere | Update database and/or update model |

| Oracle SQL Developer Data Modeler | Update database and/or update model |

| PowerDesigner | Update database and/or update model |

| Software Ideas Modeler | Update database and/or update model |

| Toad Data Modeler | Update database and/or update model |

| Tool | Teamwork/repository |

|---|---|

| Database Workbench | No |

| Enterprise Architect | Multi-user collaboration using File, DB… |

| ER/Studio | ER/Studio Repository and Team Server (f… |

| MagicDraw | Multi-user collaboration using File, DB… |

| MySQL Workbench | No |

| Navicat Data Modeler | No |

| NORMA Object-Role modeling | No |

| Open ModelSphere | No |

| Oracle SQL Developer Data Modeler | Yes |

| PowerDesigner | Yes |

| Software Ideas Modeler | Yes |

| Toad Data Modeler | Yes |

• Comparison of database administration tools

• List of Unified Modeling Language tools

• Data modeling

• IDEF1X